<?php 
require('../_Shared/PHPExcel/PHPExcel.php');
$objPHPExcel = new PHPExcel();
		$objPHPExcel->getProperties()->setTitle($listTitle);
		
		//设置格式
		$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(7);
		$letter = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
		$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->insertNewColumnBefore(7, 2);
		//生成表头		
		$objPHPExcel->getActiveSheet()->setCellValue('I1',$listTitle);
		$objPHPExcel->getActiveSheet()->setCellValue('A2','姓名');
		$objPHPExcel->getActiveSheet()->setCellValue('B2','编号');
		$objPHPExcel->getActiveSheet()->setCellValue('C2','部门');
		$objPHPExcel->getActiveSheet()->setCellValue('D2','职位');
		$objPHPExcel->getActiveSheet()->setCellValue('E2','学历');
		$objPHPExcel->getActiveSheet()->setCellValue('F2','入职时间');
		$objPHPExcel->getActiveSheet()->setCellValue('G2','转正时间');
		$objPHPExcel->getActiveSheet()->setCellValue('H2','入职月数');
		$objPHPExcel->getActiveSheet()->setCellValue('I2','转正月数');
		$objPHPExcel->getActiveSheet()->setCellValue('J2','出勤天数');
		$objPHPExcel->getActiveSheet()->setCellValue('K2','晚班E');
		$objPHPExcel->getActiveSheet()->setCellValue('L2','晚班加班O');
		$objPHPExcel->getActiveSheet()->setCellValue('M2','病假L');
		$objPHPExcel->getActiveSheet()->setCellValue('N2','时间L');
		$objPHPExcel->getActiveSheet()->setCellValue('O2','迟到次数');
		$objPHPExcel->getActiveSheet()->setCellValue('P2','忘打卡次数');
		$objPHPExcel->getActiveSheet()->setCellValue('Q2','机动日加班');
		$objPHPExcel->getActiveSheet()->setCellValue('R2','养老保险');
		$objPHPExcel->getActiveSheet()->setCellValue('S2','医疗保险');
		$objPHPExcel->getActiveSheet()->setCellValue('T2','基本工资');
		$objPHPExcel->getActiveSheet()->setCellValue('U2','工龄工资');
		$objPHPExcel->getActiveSheet()->setCellValue('V2','保险津贴');
		$objPHPExcel->getActiveSheet()->setCellValue('W2','工资小计');
		$objPHPExcel->getActiveSheet()->setCellValue('X2','员工签名');
		$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
		$objWriter->save('fxl.xlsx');
?>